Abstract: Compared with common databases, embedded databases have the characteristics of small size, complete functions, portability, and robustness. This paper analyzes and compares typical embedded databases SQLite and Berkeley dB. First, the
It is also a bit of programming memo. SQLite is a good embedded database. This embedded database is basically synonymous with exquisite and lightweight. SQLite references many scenarios, and Firefox and Android have internal applications, the code
C + + using SQLite steps and examplesDevelopment environment: Windows 10+vs2013.Development language: C + +. 1. Download SQLite file. Download URL: http://www.sqlite.org/download.html.The SQLite version is SQLite 3.11.1, related files are as follows.
Overview
SQLite Introduction
Since the advent of commercial applications decades ago, databases have become a major component of software applications. are very critical to the database management system, they also become very large and occupy a
Sqlce is too slow to compare the execution speed with SQLite.
Therefore, in the next version of the project, replace sqlce with SQLite.
After all, SQLite is not used.
The results are indeed good. Two points are satisfactory.
First, the execution
ArticleDirectory
Basic
In-Memory Database
Using UTF16
With Password
Using the pre 3.3x database format
With Connection Pooling
Read Only Connection
Using datetime. ticks as datetime format
Store guid as text
SQLite is a small database developed by a team. Because it can be stored locally and accessed offline, flashair is optimistic about this small database.Today, many developers outside China developed many ideSome 2.2 m, some less than 1 m, and some 22
Http://www.yunqa.de/delphi/doku.php/products/sqlitespy/indexSqlitespy is a fast and compact GUI, Database Manager for SQLite. It reads SQLite3 files and executes SQL against them. Its graphical user interface makes it very easy to explore, analyze,
Development1. Since EF does not support Codefirst, you can start using SQL for development.Deployment Installation2. Then you can find the SQL to SQLite tool (http://www.cnblogs.com/walkingp/archive/2010/04/08/1707834.html)3. Download a case program
Tagged with: Database sqlite Android Attribution numberFinally to use to the number of the site of the query, find a database file on the Internet, the size of more than 12M, Compressed into a zip also has 1.9M, so for an apk size is very
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.